# Setting up a data warehouse connection

This section explains how to set up data warehouse connectivity in a Qlik Compose project.

The data warehouse contains the landing zone tables (the target of the Qlik Replicate task), the logical entities, the actual data warehouse tables and the data mart tables.

For more information on the data warehouse structure in an project Qlik Compose project, see [Introduction](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Introduction/intro_compose.htm).

Note that Qlik Compose will not let you add data sources before you add a data warehouse. This is because the server connection settings for the source landing zone are derived from the data warehouse settings.

Warning note

For all supported data warehouse types, each data warehouse schema (or database if there are no schemas) should be used exclusively for a single data warehouse. In other words, using the same schema for different projects, data warehouses and landing zones is not allowed. Data mart schemas, however, can be shared by different data marts.

For more information on adding data sources, see [Setting up Landing Zone and Data Source connections](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Source%20Connections/set_up_data_source_connections.htm).

For instructions on adding a data warehouse, see the following according to your data warehouse type.

* [Using Microsoft SQL Server as a data warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/use_sql_server_as_data_warehouse.htm)
* [Using Oracle as a data warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/use_oracle_as_data_warehouse.htm)
* [Using Amazon Redshift as a data warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/use_amazon_redshift_as_data_warehouse.htm)
* [Using Microsoft Azure Synapse Analytics as a data warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/use_azure_sql_data_warehouse.htm)
* [Using Snowflake as a data warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/use_snowflake_as_data_warehouse.htm)
* [Using Google Cloud BigQuery as a Data Warehouse](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/bigquery_postgresql.htm)